package com.ztk.threadbasic.mapper;

import com.ztk.threadbasic.excel.CompanyVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 将获取的Excel中的数据入库
 */
@Mapper
public interface ExcelMapper {

    /**
     * 删除库中的 预算机构 + 预算时间数据
     */
    void deleteData(@Param("budgetAgency") String budgetAgency, @Param("budgetDate") String budgetDate);


    /**
     * 将读取的Excel内容入库
     */
    void insertReadExcelData(@Param("list") List<CompanyVO> list);

    int existsDownloadData(@Param("budgetAgency") String budgetAgency, @Param("budgetDate") String budgetDate);

    List<CompanyVO> selectDownloadData(@Param("budgetAgency") String budgetAgency, @Param("budgetDate") String budgetDate);
}
